Tabela Location

Definicja tabeli Location

Name

Location

Code

Location

Comment

 


Lista kolumn tabeli Location

Name

Code

LocationID

LocationID

Active

Active

StartDT

StartDT

StopDT

StopDT


Kolumna LocationID tabeli Location

Definicja kolumny LocationID tabeli Location

Name

LocationID

Code

LocationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli Location

Definicja kolumny Active tabeli Location

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli Location

Definicja kolumny StartDT tabeli Location

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Location

Definicja kolumny StopDT tabeli Location

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli Location

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Location

Definicja klucza Identifier_1 tabeli Location

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment